SET NAMES utf8mb4;
BEGIN;

-- 删除权限
DELETE
FROM `system_permission`
WHERE `code` = 'system:material:create'
   OR `code` = 'system:material:delete'
   OR `code` = 'system:material:update'
   OR `code` = 'system:material:query'
   OR `code` = 'system:material:excel:import'
   OR `code` = 'system:material:excel:export';

-- 删除菜单功能
DELETE
FROM `system_menu_func`
WHERE `menu_id` IN (SELECT `id`
                    FROM `system_menu`
                    WHERE `name` = '素材管理');

-- 删除菜单
DELETE
FROM system_menu
WHERE `name` = '素材管理';

COMMIT;
